import pandas as pd

path = 'numbers2.xlsx'

data = pd.read_excel(path, sheet_name=0)
items = []
for item in data['数据']:
    sp = str(item).split('.')
    if sp[1] is not '0':
        number = float('.'.join(sp))
        print(number)
        items.append(number)

print(len(items))

df = pd.DataFrame({'number': items})
df.to_excel('numbers2.xlsx')
